include("../components/hzi_connection.php"); ?>
Current Text:
hzi_mysql_connect();
$ID = $_GET['ID'];
$sql = "Select * FROM `text` WHERE `ID` = " . $ID . " LIMIT 1";
$result = mysql_query($sql)
or die("Quary failed: " . mysql_error());
$text = mysql_fetch_array($result);
echo $text['text'];
?>
if($_POST)
{
$sql = 'UPDATE `text` SET `text` = \'' . $_POST['desc'] . '\', `time_added` = \'' . time() . '\' WHERE `ID` = ' . $ID . ' LIMIT 1';
$result = mysql_query($sql)
or die("MySQL error: " . mysql_error());
echo "Text updated."; hzi_mysql_close(); } else { ?> hzi_mysql_connect(); $imageID = $_GET['ID']; $sql = 'SELECT `desc` FROM `photos` WHERE ID = ' . $imageID; $result = mysql_query($sql) or die("MySQL error: " . mysql_error()); $imagedata = mysql_fetch_array($result); ?> hzi_mysql_close(); } ?> |
||